Revalue supplier account

Find this screen

Open: Period End Routines > Foreign Supplier Account Revaluation.

Are you ready to revalue your supplier accounts?
  • If you're using default nominal accounts with cost centres and departments for any of your foreign currency supplier accounts, you'll need to make sure that you have Exchange Differences nominal accounts with the same CC / Dept combinations.

  • Make sure your exchange rates are up to date.

Cost centres

Departments

Manage currencies and exchange rates

How to

Revalue a single currency

Open: Period End Routines > Foreign Supplier Account Revaluation.

This revalues all outstanding transactions on the supplier accounts that use the selected currency. You can change the exchange rate here if you need to.

  1. Select Revalue single currency.
  2. Enter a Revaluation date. This is the date the revaluation transactions are posted. If a currency uses a period exchange rate, the exchange rate set for this date is used.
  3. Choose the currency.
  4. Click to change the exchange rate.

    If the currency uses a Period exchange rate only, the exchange rate is displayed but can't be changed.

  5. Choose whether to report or post the revaluation transactions:
    1. Produce Report Only: Produces a report showing the revalued transactions.
    2. Produce accounting adjustments: Posts revaluation transactions.
  6. Click OK.

Revalue all currencies

This revalues the outstanding transactions on all foreign currency supplier accounts, using the exchange rates set in the Currencies and Exchange rate settings. You can't change the exchange rate here.

  1. Select Revalue all currencies.
  2. Enter a Revaluation date. This is the date the revaluation transactions are posted. If a currency uses a period exchange rate, the exchange rate set for this date is used.
  3. Choose whether to report or post the revaluation transactions:
    1. Produce Report Only: Produces a report showing the revalued transactions.
    2. Produce accounting adjustments: Posts revaluation transactions.

Report on the revaluation only

Choose Produce Report Only and click OK.

A list of the potential revaluation transactions is displayed, but not revaluation takes place.

This is useful if you want to find out what the current exchange gain or loss is but don't want to post an adjustment.


Useful info

When to use this

Use this to manage exchange rate differences for your foreign currency transactions.

It's likely that there'll be changes in the exchange rate between the time an invoice is entered and when it's paid. These fluctuations are dealt with automatically by Sage 200 when a payment is allocated to an invoice.

However, you may also want to make sure that the value of outstanding foreign currency transactions reflects the latest exchange rate. If so, you can revalue these outstanding transactions here.

When you revalue your supplier accounts, Sage 200 works out the difference between the exchange rate entered when the invoice was saved and the current exchange rate. Where there is a difference, this amount is posted to the Debtors Control Account and Exchange Differences account.

Produce a report or produce accounting adjustments?

When you revalue your foreign customer accounts you can either produce a report or perform a full revaluation.

  • When you produce a report, it displays the value of outstanding transactions your supplier have with you based on the currency exchange rate applicable on the day the report is generated. Sage 200 doesn't make any amendments to the values of transactions that are held on the system. Think of it as a what-if snapshot.
  • When you produce accounting adjustments, Sage 200 updates the supplier's balances on Sage 200 based on the currency exchange rate applicable on the day you perform the revaluation.

Single or multiple currencies?

If you are revaluing a single foreign currency, you can specify the exchange to use.

If you are revaluing more than one currency, Sage 200 uses the exchange rates specified on the Currencies & Exchange Rates screen.

Revaluation rules

When your transactions are revalued the following rules are applied:

  • For currencies using a Single exchange rate:

    The exchange rate specified in the Currencies and Exchange rate settings is used.

    If you revalue a single currency, you can change the exchange rate here.

  • For currencies using a Period exchange rate:

    The exchange rate set for the period the Revaluation date falls into is used.

  • For currencies using both single and period exchange rates:

    The single or period exchange rate is used depending on which on is selected on the supplier account.

  • Transactions with a Query flag against them are not revalued.
  • The revaluation only posts the difference in the exchange rate, and not the full base value of the transaction.
  • Only outstanding or part outstanding transactions up to the specified Revaluation date, are revalued.
  • If the Revaluation date is in a future period, the revaluation values are posted to the deferred postings file.

What happens when

An account is revalued?

A revaluation transaction for each revalued account is posted to the Creditors Control nominal account and Exchange Differences nominal account. The transactions are posted using the Revaluation date.

Nominal Account Debit Credit
Creditors Control Loss Gain
Exchange Differences Gain Loss
Tip:

Don't forget, if you're using cost centre and departments with your nominal accounts, make sure you have an Exchange Differences Nominal account with the correct cost centre and department combinations. Otherwise the transaction will be posted to the suspense account.

For example. you have a customer account with a default sales account of 4000 with a cost centre MAN. When you save the revaluation, it posts to the following Exchange Differences account 8006 MAN.